const { sequelize } = require('../databases/index');

async function addSightFields() {
  try {
    // 添加设施服务字段
    await sequelize.query(`
      ALTER TABLE sights 
      ADD COLUMN facilities TEXT
    `);
    
    // 添加参观须知字段
    await sequelize.query(`
      ALTER TABLE sights 
      ADD COLUMN notice TEXT
    `);
    
    console.log('Successfully added facilities and notice fields to sights table');
  } catch (error) {
    console.error('Error adding fields to sights table:', error);
  } finally {
    await sequelize.close();
  }
}

addSightFields();